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