UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlKS8pwkzlTA8XCVWGQM5fYpTCHP/2NATzg3R47G9b8='
WHERE
key_id = 'd0fa8c6f1176ec1b997f62ada0c099ed1dadc04851c8ee205ca7d7392016f1ec'
AND (
token = 'ZlKS8pwkzlTA8XCVWGQM5fYpTCHP/2NATzg3R47G9b8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)