UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NzraZeYmCfz6Es3y77Rnk1pbhBusPMughAE2qaSLPg8='
WHERE
key_id = '0fe04d8b78f4492c6dbbce9e35100f4c946bf773a0266cdb4aaddc8cb5d80c23'
AND (
token = 'NzraZeYmCfz6Es3y77Rnk1pbhBusPMughAE2qaSLPg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)