UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9YWXVcxNV+mDVk129nenTEga2SxwZSCt1g4+JHm/V7s='
WHERE
key_id = '47548da24a4b3081af31a730526869f52aa299b65cae67be9adeb0ffe6bd8419'
AND (
token = '9YWXVcxNV+mDVk129nenTEga2SxwZSCt1g4+JHm/V7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)