UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29zEMxaWcCX+OMdwFXtPb/ZQtgduWK9QRu8G+Aa0gro='
WHERE
key_id = '7cadb805f2b1171e3f000df65a02add957706ebf21a8da50e12e8695507f8d50'
AND (
token = '29zEMxaWcCX+OMdwFXtPb/ZQtgduWK9QRu8G+Aa0gro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)