UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TrdGQYz7M5VoHNSDQtmkUzECvryFh7SreaIGRC36wgI='
WHERE
key_id = '8a5965aca957b76a724fa1603036a2dc31d6c3fd065dc8f7c765432615726078'
AND (
token = 'TrdGQYz7M5VoHNSDQtmkUzECvryFh7SreaIGRC36wgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)