UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tsQcPzERL7TNzkhPob5s6Tv6xdm2M27SiROHDbuoA4U='
WHERE
key_id = '160674f9de980ecba6773309f144b23fb9b99b04a48d312b0e131f7bfb7d0347'
AND (
token = 'tsQcPzERL7TNzkhPob5s6Tv6xdm2M27SiROHDbuoA4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)