UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DPgswG1LYwwQE5qkTmLMBxQ7LdZ5uOVM0yIL/5p1VjY='
WHERE
key_id = '05fbd27646773264844ff4999075138abd3bb91abbe93395fb5802523abbe0c9'
AND (
token = 'DPgswG1LYwwQE5qkTmLMBxQ7LdZ5uOVM0yIL/5p1VjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)