UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k40tzSEr6q5VxbJZm4jPQnS/+trEGK+V5l8fXadl6Dc='
WHERE
key_id = 'ef424049c7b237ad1ecd7ac4e3bc6d0cc71328353457ead9cc2a7f8c1590d2f4'
AND (
token = 'k40tzSEr6q5VxbJZm4jPQnS/+trEGK+V5l8fXadl6Dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)