UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3ZgJFu6fm+lHbvUGooki2gVtlRnFBlmHa2J2KBEZjw4='
WHERE
key_id = 'd867e27fe72d70d1cbe6a85eef71f199aff3b1d6b49c0f5fb3e63663c0fa82a8'
AND (
token = '3ZgJFu6fm+lHbvUGooki2gVtlRnFBlmHa2J2KBEZjw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)