UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uwjCa5y0bUlAhgokox9ob7sym/zK2Vrwk759+laxWnA='
WHERE
key_id = '0ccad1003bf7ea94a9033e99486beec5ecafec47222ab6a0f97ec2dbcd756152'
AND (
token = 'uwjCa5y0bUlAhgokox9ob7sym/zK2Vrwk759+laxWnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)