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