UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZC0mAfronct3rf/tihUZ+NvfXr+zbQ546HNSFmHb0Io='
WHERE
key_id = 'c1bf5ff080db572552d82ca11261d40cc6e27bdfc6fbb3780fbee03a8ae0b5cc'
AND (
token = 'ZC0mAfronct3rf/tihUZ+NvfXr+zbQ546HNSFmHb0Io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)