UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9KHTMnlfG14ipYpsNIGVvlxZoXTMkVx93ceCTT0JHKA='
WHERE
key_id = '5a2f0f651f79ad0b1a14b6e97acd4170d7733f4588d982fa2e47cbc368c0d60c'
AND (
token = '9KHTMnlfG14ipYpsNIGVvlxZoXTMkVx93ceCTT0JHKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)