UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wl7dw5CKaOPPkb1TMsICTNlA3B186kJm7UkXzcY9PEY='
WHERE
key_id = 'a9fea287d2c5d93f2e194879f10fb7c08d71be1e6fca09bceebea2869e8cc5db'
AND (
token = 'Wl7dw5CKaOPPkb1TMsICTNlA3B186kJm7UkXzcY9PEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)