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