UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XC7pdPBtYtgJTmHBXNHIwG3wHvqkD3B44YROo/qoDzE='
WHERE
key_id = 'd2beb6f0b272e045b7a7624096df22cd81d782ce34e8078a9a67291443354bdf'
AND (
token = 'XC7pdPBtYtgJTmHBXNHIwG3wHvqkD3B44YROo/qoDzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)