UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DvQHGCfGiyA8D0+yW0umNmRDmoxhmhywlKLW+T98cQU='
WHERE
key_id = '999bf4d25a4250ca97b43ef50f20d15c7e8d3babe8cb4d8d78fe7ae863286aba'
AND (
token = 'DvQHGCfGiyA8D0+yW0umNmRDmoxhmhywlKLW+T98cQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)