UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgWK2I1s7eXr7fd6UzM79qEtlC+l6i838I9OIjdNxTI='
WHERE
key_id = '64be6467cc0a123118eb5d837a4607c3ebe8369e9f93ccba061d27555261ab6e'
AND (
token = 'qgWK2I1s7eXr7fd6UzM79qEtlC+l6i838I9OIjdNxTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)