UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9OgnDMh79KnC3Yst93QO+0ZRCeKihXHuNxgWa3UPnCU='
WHERE
key_id = 'd907a5b499a9fd074b467f3b0ca5a9a4a34817613002d103d3127eaa97733d87'
AND (
token = '9OgnDMh79KnC3Yst93QO+0ZRCeKihXHuNxgWa3UPnCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)