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