UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKv5VHunfEpYag9yD69Z/Q0+vdafiJEIYT1jA3OZ4/E='
WHERE
key_id = '2d9b3bf83724273cf2e7db9f992ad7e36faf0f77449a80b2c150b2ef2e67fbac'
AND (
token = 'nKv5VHunfEpYag9yD69Z/Q0+vdafiJEIYT1jA3OZ4/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)