UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4VzmJynG7vtd038Dfdwf3WYmWQ5YIPHcBsGkOGitf2M='
WHERE
key_id = 'a0717adfa01fce48d257b5c0ef8608abfd31ddc3c360cbdee2aeb833cd2f3f7c'
AND (
token = '4VzmJynG7vtd038Dfdwf3WYmWQ5YIPHcBsGkOGitf2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)