UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLx/348JJbro6EHkUQTiicaAkfMtk3IvjNvk2GvDKow='
WHERE
key_id = '9cb31710d8e2a661299756584687c62f9da27fdedce27100f46a1f1d22ad9166'
AND (
token = 'oLx/348JJbro6EHkUQTiicaAkfMtk3IvjNvk2GvDKow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)