UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aI6uZkZNYSWNDW4CTlhCP3KDCptAz6ejRG2uqjdw74='
WHERE
key_id = 'a2fd03d927571434132777965e022be2cca8a168f972b90dd2016ccb48e57fdb'
AND (
token = '7aI6uZkZNYSWNDW4CTlhCP3KDCptAz6ejRG2uqjdw74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)