UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q4yTYUBfVfdMl45ymV1olw6SLm7hzUfGG1OjtWBFoH4='
WHERE
key_id = 'fa9e7af2ed75638ad93bfe26cacfdf8e5300f439508d1ad4aaf81b3107767905'
AND (
token = 'Q4yTYUBfVfdMl45ymV1olw6SLm7hzUfGG1OjtWBFoH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)