UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jqeaXAgklA5cVPJ45ZtUhilZgOFipuJZgbiKHNNBNIU='
WHERE
key_id = '686e8a9b602bc8e810b5fd52b3079e7a5612d41d4e6ddcf7422a25a88e8c32b4'
AND (
token = 'jqeaXAgklA5cVPJ45ZtUhilZgOFipuJZgbiKHNNBNIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)