UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OBpLJt2O/JJI327Zf7JZbQ5Csa2PYK4r6B0w27g7u0E='
WHERE
key_id = 'de4c97047100e0c63611e90643440fae19d61650e7469e50c048742e615267b6'
AND (
token = 'OBpLJt2O/JJI327Zf7JZbQ5Csa2PYK4r6B0w27g7u0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)