UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjZ/RNjw2miNrEK5NuUbGP1IosyEnfPbfB8Ct8J4twA='
WHERE
key_id = '2f50b994f223207bf24533726d8a5032f5e5de830b247d85f7f75e6ff3014262'
AND (
token = 'BjZ/RNjw2miNrEK5NuUbGP1IosyEnfPbfB8Ct8J4twA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)