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