UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0SgU7a6V13Qg5V18XsfGmbnHfztQz3Gw8N3BF21C46k='
WHERE
key_id = 'aff2809036251329a53c77807abde8aea5e3a39915665e9511863a3d03897055'
AND (
token = '0SgU7a6V13Qg5V18XsfGmbnHfztQz3Gw8N3BF21C46k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)