UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OcXW0cGyhd2FPoDoF94Io5evLwPeG3W1SwGBgBfjPiE='
WHERE
key_id = '06b9be2ab0df09bd58b102d90d758a3b112bbc015dee739ac6cce738109f17b8'
AND (
token = 'OcXW0cGyhd2FPoDoF94Io5evLwPeG3W1SwGBgBfjPiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)