UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1iyrcIKKD+9sRppM8XzM6cKNtXWWWTLeIcMga8+dpv4='
WHERE
key_id = '3078d529a79bceb70a0c8d4a420ae0d479197699395a33d6f177a37833adfb7a'
AND (
token = '1iyrcIKKD+9sRppM8XzM6cKNtXWWWTLeIcMga8+dpv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)