UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ruy49zUdCKOWKi+He9pGpLQrAe3vW75znz9XoH2Al+M='
WHERE
key_id = '40de3b24ae471cf1a0cf4d2853297a2bf7dd78899361b75c5cc51895b25a9bad'
AND (
token = 'ruy49zUdCKOWKi+He9pGpLQrAe3vW75znz9XoH2Al+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)