UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJpI0VMAhyGaecPqbWeExJiHp/T8PR0h7cTFCkN1r9U='
WHERE
key_id = '9b7c2afb0930c1c8996ad96f3f32c40a507a7799f0f1abbd7a69cacca1e52932'
AND (
token = 'xJpI0VMAhyGaecPqbWeExJiHp/T8PR0h7cTFCkN1r9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)